gsc_dataset_entity table — gscde
This table lists the tables that must be deployed with the data set. Each data set must have a designated primary table, in other words, the main table in the data set. The join information between the tables must also be specified.
The data in this table can be filtered using the WHERE clause stored in the filter_where_clause field.
Table 3–3 lists the table’s FLA, fields, and foreign keys.
Table 3–3: gsc_dataset_entity table information
|
Table FLA
|
Fields (data type)
|
Foreign keys
|
|
gscde
|
dataset_entity_obj (Decimal)
deploy_dataset_obj (Decimal)
entity_sequence (Integer)
entity_mnemonic (Character)
primary_entity (Logical)
join_entity_mnemonic (Character)
join_field_list (Character)
filter_where_clause (Character)
delete_related_records (Logical)
overwrite_records (Logical)
keep_own_site_data (Logical)
use_relationship (Logical)
relationship_obj (Decimal)
deletion_action (Character)
exclude_field_list (Character)
|
deploy_dataset_obj
entity_mnemonic
relationship_obj
|
Table 3–4 gives details of the table’s indexes.
Table 3–4: gsc_dataset_entity index information
|
Index name
|
Elements
|
Type
|
|
XPKgsc_dataset_entity
|
dataset_entity_obj
|
Primary Unique
|
|
XAK1gsc_dataset_entity
|
deploy_dataset_obj
entity_sequence
|
Unique
|
|
XIE1gsc_dataset_entity
|
entity_mnemonic
|
Nonunique
|
|
XIE3gsc_dataset_entity
|
deploy_dataset_obj
primary_entity
entity_mnemonic
|
Nonunique
|
|
XIE4gsc_dataset_entity
|
join_entity_mnemonic
dataset_entity_obj
|
Nonunique
|
|
XIE5gsc_dataset_entity
|
relationship_obj
|
Nonunique
|